[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '9' >
6 items
DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78 | 12.45 | 1995-08-21 | Production | james0@adventure-works.com | James Kramer | 119-555-0117 | 339712426 | James | M | 2020-01-23 | Kramer | adventure-works\james0 | M | D | 9 | 1 | 119-555-0117 | 39 | 2020-01-23 | Current | Production Technician - WC60 | 39 | |
39 | 12.45 | 2001-06-12 | Production | simon0@adventure-works.com | Simon Rapier | 963-555-0134 | 276751903 | Simon | M | 2020-01-04 | Rapier | adventure-works\simon0 | S | D | 9 | 1 | 963-555-0134 | 39 | 2020-01-04 | Current | Production Technician - WC60 | 38 | |
86 | 12.45 | 1999-12-16 | Production | nancy0@adventure-works.com | Nancy Anderson | 970-555-0118 | 693325305 | Nancy | F | 2020-01-29 | Anderson | adventure-works\nancy0 | M | A | 9 | 1 | 970-555-0118 | 37 | 2020-01-29 | Current | Production Technician - WC60 | 34 | |
125 | 12.45 | 1984-09-22 | Production | bryan0@adventure-works.com | Bryan Baker | 712-555-0113 | 458159238 | Bryan | M | 2020-02-17 | Baker | adventure-works\bryan0 | S | 9 | 1 | 712-555-0113 | 37 | 2020-02-17 | Current | Production Technician - WC60 | 35 | ||
160 | 12.45 | 1987-03-08 | Production | eugene1@adventure-works.com | Eugene Kogan | 173-555-0179 | 66073987 | Eugene | M | 2020-03-06 | Kogan | adventure-works\eugene1 | S | O | 9 | 1 | 173-555-0179 | 38 | 2020-03-06 | Current | Production Technician - WC60 | 36 | |
198 | 12.45 | 1997-02-05 | Production | thomas0@adventure-works.com | Thomas Michaels | 278-555-0118 | 500412746 | Thomas | M | 2020-03-24 | Michaels | adventure-works\thomas0 | M | R | 9 | 1 | 278-555-0118 | 38 | 2020-03-24 | Current | Production Technician - WC60 | 37 |
Generated 2025-07-26 05:12:23.521 UTC